package com.hake.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

/**
 * Created by Administrator on 2017/4/1.
 */
@Service
public class PetUserServiceImpl implements PetUserService {
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public int add(String user_id, String pet_owner_name, String pet_owner_phone, String pet_owner_qq, String pet_owner_wx, String pet_owner_card_type, String pet_owner_card_number, String pet_owner_place, String pet_owner_street, String pet_owner_photo, String pet_name, String pet_type, String pet_sex, String pet_birth, String pet_immune_no, String pet_immune_group, String pet_immune_able_date, String pet_birthday, String pet_id_no, String pet_police_station, String pet_photo_positive, String pet_photo_side) {
       return jdbcTemplate.update("insert into t_pet_user(user_id,pet_owner_name,pet_owner_phone,pet_owner_qq,pet_owner_wx,pet_owner_card_type,pet_owner_card_number,pet_owner_place,pet_owner_street,pet_owner_photo,pet_name,pet_type,pet_sex,pet_birth,pet_immune_no,pet_immune_group,pet_immune_able_date,pet_birthday,pet_id_no,pet_police_station,pet_photo_positive, pet_photo_side) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",user_id,pet_owner_name,pet_owner_phone,pet_owner_qq,pet_owner_wx,pet_owner_card_type,pet_owner_card_number,pet_owner_place,pet_owner_street,pet_owner_photo,pet_name,pet_type,pet_sex,pet_birth,pet_immune_no,pet_immune_group,pet_immune_able_date,pet_birthday,pet_id_no,pet_police_station,pet_photo_positive, pet_photo_side);
    }
}


